<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.SQLException" %><%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2018/3/27 0027
  Time: 下午 8:07
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<p><a href="userList.jsp">返回列表</a></p>
<%
    request.setCharacterEncoding("UTF-8");
    String username = request.getParameter("username");
    String password = request.getParameter("password");

        Connection connection = null;
        Statement statement = null;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:" +
                    "3306/sctu-javaweb-2018?serverTimezone = " +
                    "UTC&&characterEncoding = UTF-8", "root", "123456");
            statement = connection.createStatement();
            statement.executeUpdate("INSERT INTO t_users(username,password)"+
                    "VALUES('" + username + "','" + password + "')");

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                connection.close();
                statement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
%>
<script>
    alert("提交成功！")
</script>
<%@ include file="footer.jsp"%>
</body>
</html>
